A header and a footer? I'm out of my depth now. Sounds like something you'd user Reporting Services for. Do you have a sample of what the...

Sounds like you're being taught to run before you can walk. Those are columns, not rows.

SELECT col1, col2, col3 FROM MyDB.dbo.USERS

John

You tell me - you have access to the file; I don't.

John

You haven't read about fully qualified object names, have you? Nor have you read Phil's suggestion properly. The only way your code will work is if you have...

Are you sure tm37_1_2_online isn't the database name, because dbo sounds like the schema name. Just swap it round with dbo and it should work.

As a bit of background...

Unless the USERS table exists in the default database for your user, you will need to qualify it with the database (and maybe also schema) name:

SELECT * FROM MyDB.MySchema.USERS

By the...

Error message? File not created? Data in wrong format in file? Other problem? Please be more specific, and help us to...

Welcome to SQLServerCentral. We're all to help you, however most of us draw the line at doing your homework for you. Please have a go at doing it...

Beware of SQL injection when you use dynamic SQL. I recommend you read this.

John

Please will you post some sample data and expected results based on that data? I'm struggling to understand whether you want everything between 7:30 and 8:30 on a particular...

If you're not comfortable with Script Tasks then you can insert into a staging table. Write a stored procedure to populate a unique value column, (probably using ROW_NUMBER), and...

Yes. After you restore the database from the backup, transactions commenced while the backup was being taken will either be rolled back or rolled forward, so that the database...

If you look at the properties of the Union All editor, you'll get a list of all columns in one input alongside a list of all columns in the other....

OK, so the MAJ Clients OLE DB Command only feeds the Union All (Tous les clients) transformation? Can you not restrict the number of columns in the output of...

Can you show us what your data flow looks like, please?

Thanks

John