As I read the description of dtexec at BOL, the statement should take the following form:

dtexec /f mypackage.dtsx /set \package.variables[myvariable].Value;myvalue

This without the Properties.

Can you try that?

In my native language, schema and diagram are synonyms.

You should've asked your question more clearly.

But on to the question:

click on Database in the menu and then choose Generate Relation Schema.

A...

The answer is: it depends 🙂

If the reports requires data that is the result of very complex operations, I would consider a cube, since the data is precalculated over night....

Maybe this is an option:

right before you read your flat file, edit the file with a script task. Go to the last row, place something before the number and add...

Try checking the folder sysssispackages. If they are not there and they are not somewhere else in the MSDB folder, well, then I don't have a clue 🙂

More information about...

I'm not sure what you're asking.

If you mean how to create a schema (aka diagram) in the Data Source View, follow these steps:

1. Right-click on an item in the Diagram...

Can you show us the code that you're using to execute dtexec?

To pass variables along with dtexec it should be something like this:

DTExec /SQL "\PkgTest" /SERVER "(local)" /SET "\Package.Variables[User::varFile].Value";"File_001.xls" /MAXCONCURRENT...

I'm confused. I saw nothing about a conditional split.

If the flat file source can read all rows, even the last one, you can try to filter the last row out by using a conditional split.

The condition to find...

I see you don't use Windows Authentication in your connection string.

Shouldn't you provide a proper user name and password?

(if needed by your systems security settings)

In Management Studio, you can connect to Integration Services.

(choose Connect and then click Integration Services...)

There you will see two folders:

Running packages and Stored packages. We will look at the last...

Business Intelligence Development Studio, aka BIDS, is actually plain old Visual Studio. When you start Visual Studio for the first time, you can choose a 'role'. For example, .NET developer,...

This is a double post.

Please refer to:

http://www.sqlservercentral.com/Forums/Topic874531-364-1.aspx

When I have to use temp tables in my packages, I always use global temp tables, like ##temp and with the property RetainSameConnection set to True (as said before by...

I don't know how you create your recordset, but couldn't you store the records in a temp table instead of a recordset and use this table for your lookup?