Check you Excel if it really has Sheet1 present or not. Also try configuring this Excel as a source, may be the sheet you are referring is not available.

You can...

Yes, you can do this in SSRS. Try using below query in your dataset and create a table in your report to display the output.

SELECT name, SUM(count), MAX(modified) as last_modified

FROM...

As your procedure already...

If the excel sheet is present on your system and metadata is correct. Try running your package in 32 bit mode.

Right Click Project -> Properties -> Debugging -> Run64bitRuntime to...

Assing connection string value to a Variable in Child package and try using that variable value as connection string to your connection using expressions.

You can check below post which is...

Use an ETL tool...or easy way..use SQL Server Import/Export wizard with SQL Server Authentication.

Use SSIS instead. It is easier and faster.

But, if in case you have to do it in SQL Server only. Then write an SP, validate all records in the staging...

Create a new Table Type with Columns ProductId and Stock.

Pass this table type as parameter to the SP.

Then join your main table and this parameter table to update your main...

You can do it using command line -

AcroRd32.exe /t <file.pdf> <printer_name> <printer_driver> <printer_port>

Eg: 2Printer.exe -s "C:\In\*.PDF" -prn "HP LasetJet 1100"

Or, you can do it using Scrip Task in C#...

We cannot use any wild cards in file name while sending it using FTP.

Rather while creating this file, store the file name in an SSIS variable and use that variable...

If you have an extra , (comma) at the end of rows in a 'csv' file. This means you have an extra column.

Just update your file connection manager and remove...

rocky_498 (2/9/2015)

---

Opps I should mention.

I am using so far two transformations ( Derived Column, Data Conversion)

Plus I am using SCD..

That would be next question. If I pick Second Option...

Or try storing 0 (False) or 1 (True) instead.

you can schedule your package with the SQL job and then check the all information from (msdb..dbo.sysjobhistory) table.

OR

you can use the system variable ("StartTime") and end time with the help...

Yes, you can use one config file in multiple packages. Just make sure config file name is same in all the packages.

Packages will automatically pick the config values available for...