i dint know how to map your tables but the basic SQL would look like this if you want no of days from startdate to current date

SELECT C.* , DATEDIFF(Day,...

Rt clk on the Excel destination, then select advanced and see the Input/Output column data types they should match.. if they dont just open up Excel destination In the...

If your SQL is getting you all the images then you just need to make rank() or row_number() function part of your SQL as below

SELECT dbo.tblVara.fldKategori, dbo.tbVara.fldVaraID, dbo.tblVara.fldRubrik, dbo.tblAnAddVara.fldText, dbo.tblVara.fldPris,...

click on Excel connection Manager and on the rt side Property pane you should see Expressions.. you will also see a Connection string property, try to make a note of...

Did you try using Row_Number() Function in SQL?? its simple and would give you the same results ... Partition them on Seq,meter

Did you change the connection String Property of your EXcel File which should look something like this based on your EXCEL Version. The Variable "ExcelFilePath" holds the path of the...

🙂 I agree with you on that Phill, I was just trying to help him with the code their.....

Replace "+" with "&" that should do it

FileDate = "-" & strDay & "\" & strMonth & "\" & strYear

My First thought would be to try using ROW_Number() function and just select 1 row based on your condition if any.... can you post your table definitions with some sample...

you add the ForEach Loop to the package do you drag it on to the work area and then drop the connection inside of the loop or do you...

Use a execute SQL task to get distinct Column data and Then use a FEL to loop on that column data, Place a execute SQL task and a Data Flow...

ronaldkrex (3/24/2010)

---

I have been running the query below. For some reason I can type a value for name that I know is in the Name Field and I don't get...

I looked at the example you referenced and downloaded the sample file the author provided but its still not clear. What I rally need is an on line sample/example...

Use Import/Export wizard in SSIS to complete the Data Flow Task part. You will be left with Control Flow task and all you need to do is use a For...

SQL command from Variable should work..What is the Error that you are getting ? Are the SSIS variable data types same as your Function variables ??