BCP data import

Anyone knows what is the syntax for BCP import for a comma delimited and
double quote text qualifier text file ? I have tried almost all the options
but still can't figure it out. I keep getting different error messages.
T.I.A
Hi
You can use BCP with the format option to get a format file that you can
change. Alternatively look at using DTS/SSIS see
http://www.sqldts.com/default.aspx?246
John
"DXC" wrote:
[vbcol=seagreen]
> Format file for 221 text files !!!!!
> "John Bell" wrote:
|||Format file for 221 text files !!!!!
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> See Erlands post http://tinyurl.com/yf6z2u
> John
> "DXC" wrote:
|||Hi
See Erlands post http://tinyurl.com/yf6z2u
John
"DXC" wrote:

> Anyone knows what is the syntax for BCP import for a comma delimited and
> double quote text qualifier text file ? I have tried almost all the options
> but still can't figure it out. I keep getting different error messages.
> T.I.A

BCP data import

Anyone knows what is the syntax for BCP import for a comma delimited and
double quote text qualifier text file ? I have tried almost all the options
but still can't figure it out. I keep getting different error messages.
T.I.AHi
You can use BCP with the format option to get a format file that you can
change. Alternatively look at using DTS/SSIS see
http://www.sqldts.com/default.aspx?246
John
"DXC" wrote:
[vbcol=seagreen]
> Format file for 221 text files !!!!!
> "John Bell" wrote:
>|||Format file for 221 text files !!!!!
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> See Erlands post http://tinyurl.com/yf6z2u
> John
> "DXC" wrote:
>|||Hi
See Erlands post http://tinyurl.com/yf6z2u
John
"DXC" wrote:

> Anyone knows what is the syntax for BCP import for a comma delimited and
> double quote text qualifier text file ? I have tried almost all the option
s
> but still can't figure it out. I keep getting different error messages.
> T.I.A

Basket Analysis

Hi everyone,

Who knows how to write a MDX to do basket analysis based on cube?

Thanks

Hello! I think that this is a task for the distinct count aggregation method on the measure you have choosen,

You have also the option to work with data mining in SSAS2005 for this analytic topic.

HTH

Thomas Ivarsson

|||

Incase if you use Predictive Modelling algorithm in datamining for Market Basket Analysis, Use DMX to achieve this.

Thanks

Subhash Subramanyam

|||

Sacha has just done a really good blog on this:

http://blogs.adatis.co.uk/blogs/sachatomey/archive/2007/08/22/basket-analysis-using-analysis-services-2005.aspx

HTH

Tim

Basket Analysis

Hi everyone,

Who knows how to write a MDX to do basket analysis based on cube?

Thanks

Hello! I think that this is a task for the distinct count aggregation method on the measure you have choosen,

You have also the option to work with data mining in SSAS2005 for this analytic topic.

HTH

Thomas Ivarsson

|||

Incase if you use Predictive Modelling algorithm in datamining for Market Basket Analysis, Use DMX to achieve this.

Thanks

Subhash Subramanyam

|||

Sacha has just done a really good blog on this:

http://blogs.adatis.co.uk/blogs/sachatomey/archive/2007/08/22/basket-analysis-using-analysis-services-2005.aspx

HTH

Tim

basic vs. advance

Hi,
Does anyone knows the differences or if there is a document available
explaining the differences between the following under SQL 2005 server:
Basic ETL and Advance ETL
Standard OLAP and Advance OLAP
Standard Reporting and Advance Reporting
Thanks
Mark
I'm interested in knowing too...
burt_king@.yahoo.com
"Mark" wrote:

> Hi,
> Does anyone knows the differences or if there is a document available
> explaining the differences between the following under SQL 2005 server:
> Basic ETL and Advance ETL
> Standard OLAP and Advance OLAP
> Standard Reporting and Advance Reporting
>
> Thanks
> Mark
>
>
>
>

basic vs. advance

Hi,
Does anyone knows the differences or if there is a document available
explaining the differences between the following under SQL 2005 server:
Basic ETL and Advance ETL
Standard OLAP and Advance OLAP
Standard Reporting and Advance Reporting
Thanks
MarkI'm interested in knowing too...
--
burt_king@.yahoo.com
"Mark" wrote:

> Hi,
> Does anyone knows the differences or if there is a document available
> explaining the differences between the following under SQL 2005 server:
> Basic ETL and Advance ETL
> Standard OLAP and Advance OLAP
> Standard Reporting and Advance Reporting
>
> Thanks
> Mark
>
>
>
>

basic vs. advance

Hi,
Does anyone knows the differences or if there is a document available
explaining the differences between the following under SQL 2005 server:
Basic ETL and Advance ETL
Standard OLAP and Advance OLAP
Standard Reporting and Advance Reporting
Thanks
MarkI'm interested in knowing too...
--
burt_king@.yahoo.com
"Mark" wrote:
> Hi,
> Does anyone knows the differences or if there is a document available
> explaining the differences between the following under SQL 2005 server:
> Basic ETL and Advance ETL
> Standard OLAP and Advance OLAP
> Standard Reporting and Advance Reporting
>
> Thanks
> Mark
>
>
>
>