Search results for query: *

Yes I'm using the Import/Export wizard. What is SP1? What is BIDS? Forgive my ignorance, I set up my stuff on 2000 two years ago and haven't had to use these tools before.

I am importing data from flat file source to destination tables that were created in SQL 2000 (imported to SQL 2005). I finally figured out that I had to match the column in source and destination file so I get past the validation errors. Below is the error I am getting now. The column in my...

I have tried the "avoid duplicate rows in aggregation" format for table, but when I use the variable in another report the duplicate lines do not calculate correctly. Line 1 20.16 Line 2 21.10 Line 3 20.16 Answer should be 61.42, and it is - until I try to use the sum value in...

This is the loop: Table 1 to Table 2, Table 2 to Table 3, Table 3 to Table 4, Table 4 to Table 5 and Table 5 to Table 2. Info in Table 5 and Table 2 have common columns. When I run two seperate queries, using table 1 and table 2, no problems, but there is column in table 1 that need to be...