I am not SQL person but try to learn. Just too much to learn. We have someone created a SSIS import /export package which was not published into SQL. 1) how to modify some column in the SSIS package such as change CLientID to ClientNumber. 2)How to develop SSIS package into SQL DB? I tried it by following some free tutorial but I cannot see develpe option by right click Manifest file.

First create a project in BIDS and then add this package, thereafter through the right click menu use Edit on most items of interest. Arthur My Blog

BID is created already. I want to know how to add column. I reconfigured a text file to generate 18 columns but I only can see Available Input Column but cannot see anything to map the number 18 (column) in Available destination column How to add a column in GUI or query in SSIS not on SQL DB?

can we see that? post image linkArthur My Blog

I cannot insert the images

It is under OLE DB Destination Editor. Available INPUT Column Available Destination Column Column 1 ------------------Client ID Column 5 ------------------Tax ID Column 18 (new one) ------------- no mapping (we want to map LoanID ) I only see delete column and but cannot see an option to add one.

Hi Ginger, Try https://skydrive.live.com/ To enable you to link to images within a thread. I hope this helps. Kieran.If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood

I have already uploaded a doc with screenshot.

Where?Arthur My Blog

you may need to use the skydrive.live.com to vbiew it.

And where is the link? Arthur My Blog

While we are waiting please see this blog post on exactly what you need (my guess): http://sqlserverpedia.com/blog/sql-server-bloggers/behold-ssis-advanced-editor-for-data-source-components/ This article show the advanced source editor where you must be able to conduct any necessary changes.Arthur My Blog

https://skydrive.live.com/#cid=FDC3041ACDAB4C24&id=FDC3041ACDAB4C24%21115

This is not the right place to do that modification. To rename a column use the Advanced Editor on the source (right click on it) in the link I provided above.Arthur My Blog

Thanks! So I can add a column by using the Advanced Editor?

No to add you need a Derived Column Transformation (the easiest approach) see the add as new: http://sqlblog.com/blogs/andy_leonard/archive/2009/02/04/ssis-expression-language-and-the-derived-column-transformation.aspxArthur My Blog

It didn't work with Advanced Editor. See the secodn doc attached: I only can rename it in SQL DB mgmt studio https://skydrive.live.com/#cid=FDC3041ACDAB4C24&id=FDC3041ACDAB4C24%21115