Wildcat: thx for the response. Can u give me a hint as to what print function should I search for?

I went to SSIS. In the OLE DB Source I inputted my query as shown in the original post. Then I selected the Flat file destination. The package ran with...

I have not reached the point of writing to disk yet. Trying to format my query to pull all the data elements.

Thanks for the response Roy. Yes-indeed both of these servers are on different domains. I also have another problem where I can ping from one server to the other-can connect...

Thanks Frank. I checked all the permissions and I am still getting the same error. I have an excel spreadsheet that I am trying to import. It has...

Thanks for the advise. I will find a math forum and post there. Any know of math forums?

Lynn: You hit the nail right on the head. That is exactly what he is looking for.This is a tiny shop. There is no front-end developer. Just myself as...

He has multiple box sizes and multiple bottle sizes. I will have him give me the the physical dimensions of the bottles, not their volume and repost the info...

He wants me to do this in sql using some sort of an algorithm. If it was just one size bottles, I could pre determine of many of each...

My bad the last statement does contain \r:

68 SQLCHAR 0 50 "\r" 67 ORDER_NO ""

can someone please help me? What am I doing wrong?

My data file used to look like this

...."GVI PRINT AD DEF","","","",""

with the format file:

63 SQLCHAR 0 30 "\",\""...

Excuse my stupidity.

I see that in my last post the data file had a comma missing between a field.

Here is my file:

"RECORD_ID","SOURCE_ID","MEDIA","CREATED_BY","DATE_ORD","AMT","F_NAME","ORD_TIME"

"MLMORD20140571","7499582HG","GVAUTO","NANCY",20080616,100.00,"WALLY","02:21:08 PM"

"MLMORD20141711","7504735LS18","GVAUTO","BILL",20080616,100.00,"ROB","11:17:13 PM"

Here is my format file

9.0...

The data provider threw ina new kink, now my data looks like this:

"RECORD_ID","SOURCE_ID","MEDIA","CREATED_BY","DATE_ORD","AMT","F_NAME","ORD_TIME"

"MLMORD20140571","7499582HG","GVAUTO","NANCY",20080616,100.00,"WALLY","02:21:08 PM"

"MLMORD20141711","7504735LS18","GVAUTO","BILL",20080616,100.00,"ROB""11:17:13 PM"

So, I created this format file:

9.0 ...

I am real close to finding my solution. Just need a little help:

Now my format file looks like this:

9.0 ...

David/Jeff-anyone out there:

So, if the file looks like this

"RECORD_ID","SOURCE_ID","MEDIA","CREATED_BY","DATE_ORD","AMT","ORD_TIME"

"MLMORD20140571","7499582HG","GVAUTO","NANCY",20080616,100.00,"02:21:08 PM"

"MLMORD20141711","7504735LS18","GVAUTO","BILL",20080616,100.00,"11:17:13 PM"

Now, I have two numeric fields DATE_ORD,AMT next to each other, how do I specify it in the format...